FO_External_Form_Definitions
Not required maintenance but needed for embedding external reports using Microsoft SQL server reporting URL based pointers. (The external URLs made using SSRS reporting function.)
Field |
Type |
Notes |
ExternalForms_ID |
bigint |
Identity (counter) field |
ExternalFormCode |
varchar(50) |
Unique code string to identify a single report. |
Description |
varchar(255) |
Description for the report. |
ReportURL |
varchar(800) |
URL that launches the report in the SSRS server. |
ReportType |
varchar(50) |
A short coded value that identifies the type of the report. Use valid XXXX code (of what nature?) |
CreateDate |
datetime |
Date record was created. Informational |
EditDate |
datetime |
Date record was edited. Informational |
CreateUser |
varchar(50) |
User who created the record. Informational |
EditUser |
varchar(50) |
User who edited the record. Informational |
FPModule |
varchar(50) |
Swaps the default Rhodes format for the SSRS form defined. Use a valid FPModule code to enable. Valid FPModule Code: BATCHPROCESS |
PermGroups |
varchar(1000) |
Determines which users can see a report based on permission group codes. Leave blank to make report available to all users. Multidimensional pipe delimited value. Use valid permission group codes separated by pipes with leading and trailing pipes. |